🕷️️ Job Radar • SCRAPING

upwork.com 🟡 2026-05-26

🔹 Automated E-commerce Monthly Sales Reporting System
👤 Client: 🇺🇸 United States Member since 2025-09-25
💰 Price: ****
🚩 Problem: Manual data aggregation and summarization from multiple Google Sheets tabs causing operational inefficiency.
📦 Existing: Google Sheets (Sales, Returns, Expenses tabs)

Specifications:

[Target] Google Sheets API
[Method] Python automation
[Method] Scheduled monthly triggers (1st of month)
[Format] Monthly summaries: Total revenue, Top-performing products, Net profit
[Target] Email distribution to 3 team members
[Stack] Python

Workflow:

1. Integration of Google Sheets API for data extraction from multiple tabs.
2. Implementation of Python logic for revenue, product performance, and profit calculations.
3. Configuration of automated email delivery system.
4. Setup of monthly scheduling trigger.
5. Validation via sample report and test run.